#Excel spreadsheet to database

[trunao]

Using Excel for Data Management is Risky?

Somehow a possibility of loose data. Many organizations depend on excel to manage their data in excel, which is the reason for numerous database losses. Trunao helps you to protect your data using Excel to a web application. For more detail visit our blog.

[irishbreakfst]

I hate running out of desk work to do cuz then I have to ask the people working on the Worst Most Convoluted Project Ever if they need any help. And they always need help.

[chornayadrakoshig]

Well that was fun while it lasted, I guess it's to set up shit manually on notion or something

[copperbadge]

I never learned how to properly make a spreadsheet! I congratulate you on your initiative and skill.

…I should probably check out that free Excel class from my public library lol.

Honestly, I never had a formal class in it either -- I just fucked around in it and eventually got trained by colleagues and the necessities of the job. :D I do encourage people to learn spreadsheet basics because it's a really helpful way to track information and also to analyze data, and the library classes are a GREAT way to go about it! But also you can just start makin' sheets and every time you want it to do something and don't know how to do it, give it a google.

Google Sheets is free and slightly, I think, more accessible than Excel, but a lot of stuff differs between the two, so if you train in Google Sheets, do be aware that you can do more and different things (and sometimes have to do different things to get the same result) in other programs.

Spreadsheets I don't think were ever meant to be the backbone of most modern data management, but most databases do eventually break down into "well, you can export it as a spreadsheet" so it's a very handy skill to have :) Good luck!

[tessasilverswan]

Latest AO3 scrape into AI database

Please read this if you're an AO3 user with public, not archive-locked works. This is information on the latest known instance of someone taking AO3 works to build datasets on which to train AI and the ongoing process to get them removed. I don't really make posts adressing people, but I am furious about my work being used and I know some of my mutuals don't have their fics archive-locked so I hope I can at least get the information to some people.

Earlier this month (April) a, to my understanding, rp fanworks website named PaperDemon.com got word that a user of an AI dataset website, HuggingFace, had scraped its contents, as well as those of a bunch of other websites among which AO3 is included, where they can be freely downloaded to train generative AI models. For AO3 specifically, the user themselves reports that all public works with IDs ranging from 1 to 63,200,000 have been scraped.

As of April 25 and per the updating Paper Demon publication, 2 of 8 affected sites have gotten their content removed and the rest have achieved temporary disabling (supposedly data is visible but not downloadable) pending a counter-notice from the scraper, who appears to be set on the aim of dismissing the request as unfounded. Furthermore, the AO3 dataset has already been downloaded 2,244 times in the last month. On earlier updates of the PD post they mentioned that the scraper agreed to remove, on an individual basis, the content of those who file a Copyright infringement report. So far there are about 150 reports against the AO3 dataset. The scraper also uploaded them to another website, but appears to have removed at least the PD ones, as well as to his personal website which the PD post doesn't even link for safety reasons. The platform HuggingFace has also been made aware of the situation (that's what got us the temporary disabling)

I have personally filed a Copyright infringement report using the helpful guide put together by the PD team and have emailed the scraper on the address listed there providing the title and URL of my work and requesting for it to be removed from the dataset.

I have one concern regarding the PD guide, though (disclaimer: this is coming from someone with a very limited knowledge on computers & digital information and my understanding of the majority of concepts is from 3h of internet searches + ms help page + messing around in my laptop) They rightly recommend to not publish the work URLs in the report and instead instruct to collect them in a spreadsheet in .cvs filetype. This, however, has a problem of personally-identifying metadata being stored "alongside" the file itself and it can be accessed. The MS Excel Inspector tool allows the removal of this type of data, but apparently only when it's shared through the MS account? For Google sheets there is a different problem, which is that you can't just make your spreadsheet in .csv filetype, you need to download it and the reupload it (if there is a way, it's not easily accessible; i looked at like 4 step-by-step guides and they all said to download) which again adds properties to the file that may contain personal information.

I was very sleep deprived and very close to giving up, because I do not wish to provide a person that's massively stealing content any information linked to my identity, but then I thought I could just send the info on the email body itself. It's not the best solution but I think it's better than the alternative.

I am beyond mad that this happened and will archive-lock my affected work as soon as I receive a response (or after enough days of silence, I guess, but I hope my report won't be ignored). Unfortunately I can't file a DMCA take-down notice, because it requires personal information which might be shared with the infringer if they file a counter-notice, but I have hope that, if everyone whose works were scraped files Copyright infringement reports, AO3's DMCA won't be dismissed.

I encourage anyone who has read this to also file a report to get their work(s) removed asap and, if anyone is more informed or knowledgeable on the topic, to please share any useful info you have. I might also email AO3 to inquire about the DMCA status later because the PD publication is understandably only really tracking theirs.

[ladysatoru]

one piece characters and would they use excel or google sheets : the strawhats

Luffy : accidentally deleted nami's budget sheet that one time and has been banned from using the crew's common computer without supervision. thinks excel is a new type of snack, everytime someone mentions a spreadsheet he spreads a sheet on the floor and takes a nap

usopp : both. currently trying to train luffy by going pavlov style but it's no luck cz luffy keeps forgetting everything the next day

zoro : neither. keeps his logs in a bloodstained notebook

nami : exclusively uses google sheets to keep log of all the ppl she roped into whatever pyramid scheme she got going on at the moment. Got separate backed up files on weather data, the ship's budget, and zoro's debt schedule

robin : excel. actually is an excel scientist who recommends new features and formulas. But all her proposals are just morbid and makes the senior management terrified. her latest project "formula on how likely someone is to die based on their last 5 decisions" is currently waiting for approval in the headquarters

sanji : google sheets. every sheet is color-coded, ingredient-tagged, and automatically generates weekly menus based on the crew's preferences. Has special filters for nami-robin's hormonal cycles and his annoyance level towards zoro. puts love notes in the comment section and sends heart-shaped graphs to nami and robin in leisure time

chopper : both, he might be a baby but he's a capricorn. started hustling right after he popped out off the womb.

franky : excel. everything is password protected but rumour has it that if u type SUPERRR in a specific cell of his spreadsheet, it starts the process of launching a missile

brook : neither. accidentally deletes data all the time and blames it on being dead yo ho ho

jinbei : excel. neat spreadsheets, and very organized. Has a password protected hidden database containing timestamped entries of everytime zoro and sanji did some unnecessary homoerotic shit in the middle of a serious battle. everytime he updates it, he gotta meditate next to the ocean for 2 hrs

[otmaaromanovas]

Have your say on the database!

I've been working pretty intensely on the database of the Romanov's friends, acquaintances, staff, ladies-in-waiting, etc, for the past few days, and now have over 100 names! I planned to create this database a few years ago so it could be consulted to easily find people that OTMA mention in their diaries.

The question is... when I publish the database, what platform should I use?

Notion - makes the database easily shareable by a link, and helpful for adding photos, but might be an unfamiliar platform to some users

Excel spreadsheet - great for searching and sorting (alphabetically, by year, etc), but would need to be downloaded to be used to its full potential, and not very useful for adding photos

Website - would be able to customise well to make finding information easy, but likely the most difficult to set up

Each person in the database will have as much information on them as possible, including:

their full name

nicknames for them used by the Romanovs and alternative spellings of their name (for example, the name 'Elizaveta' often turns into 'Elizabeth' in English sources)

their job

how they knew the family, and, if applicable, what the family thought about them using diaries and letters

a biographical sketch of their life

their dates of birth and death

details on any sources they left behind (such as memoirs, photographs, etc)

photographs of the person

references

Would love to hear what you guys think :)

[codingquill]

SQL Fundamentals #1: SQL Data Definition

Last year in college , I had the opportunity to dive deep into SQL. The course was made even more exciting by an amazing instructor . Fast forward to today, and I regularly use SQL in my backend development work with PHP. Today, I felt the need to refresh my SQL knowledge a bit, and that's why I've put together three posts aimed at helping beginners grasp the fundamentals of SQL.

Understanding Relational Databases

Let's Begin with the Basics: What Is a Database?

Simply put, a database is like a digital warehouse where you store large amounts of data. When you work on projects that involve data, you need a place to keep that data organized and accessible, and that's where databases come into play.

Exploring Different Types of Databases

When it comes to databases, there are two primary types to consider: relational and non-relational.

Relational Databases: Structured Like Tables

Think of a relational database as a collection of neatly organized tables, somewhat like rows and columns in an Excel spreadsheet. Each table represents a specific type of information, and these tables are interconnected through shared attributes. It's similar to a well-organized library catalog where you can find books by author, title, or genre.

Key Points:

Tables with rows and columns.

Data is neatly structured, much like a library catalog.

You use a structured query language (SQL) to interact with it.

Ideal for handling structured data with complex relationships.

Non-Relational Databases: Flexibility in Containers

Now, imagine a non-relational database as a collection of flexible containers, more like bins or boxes. Each container holds data, but they don't have to adhere to a fixed format. It's like managing a diverse collection of items in various boxes without strict rules. This flexibility is incredibly useful when dealing with unstructured or rapidly changing data, like social media posts or sensor readings.

Key Points:

Data can be stored in diverse formats.

There's no rigid structure; adaptability is the name of the game.

Non-relational databases (often called NoSQL databases) are commonly used.

Ideal for handling unstructured or dynamic data.

Now, Let's Dive into SQL:

SQL is a :

Data Definition language ( what todays post is all about )

Data Manipulation language

Data Query language

Task: Building and Interacting with a Bookstore Database

Setting Up the Database

Our first step in creating a bookstore database is to establish it. You can achieve this with a straightforward SQL command:

CREATE DATABASE bookstoreDB;

SQL Data Definition

As the name suggests, this step is all about defining your tables. By the end of this phase, your database and the tables within it are created and ready for action.

1 - Introducing the 'Books' Table

A bookstore is all about its collection of books, so our 'bookstoreDB' needs a place to store them. We'll call this place the 'books' table. Here's how you create it:

CREATE TABLE books ( -- Don't worry, we'll fill this in soon! );

Now, each book has its own set of unique details, including titles, authors, genres, publication years, and prices. These details will become the columns in our 'books' table, ensuring that every book can be fully described.

Now that we have the plan, let's create our 'books' table with all these attributes:

CREATE TABLE books ( title VARCHAR(40), author VARCHAR(40), genre VARCHAR(40), publishedYear DATE, price INT(10) );

With this structure in place, our bookstore database is ready to house a world of books.

2 - Making Changes to the Table

Sometimes, you might need to modify a table you've created in your database. Whether it's correcting an error during table creation, renaming the table, or adding/removing columns, these changes are made using the 'ALTER TABLE' command.

For instance, if you want to rename your 'books' table:

ALTER TABLE books RENAME TO books_table;

If you want to add a new column:

ALTER TABLE books ADD COLUMN description VARCHAR(100);

Or, if you need to delete a column:

ALTER TABLE books DROP COLUMN title;

3 - Dropping the Table

Finally, if you ever want to remove a table you've created in your database, you can do so using the 'DROP TABLE' command:

DROP TABLE books;

To keep this post concise, our next post will delve into the second step, which involves data manipulation. Once our bookstore database is up and running with its tables, we'll explore how to modify and enrich it with new information and data. Stay tuned ...

Part2

[bluegamba]

Sims 2 Painting Sizes Database

I made this table for myself because it was taking me too much time to find a good mesh to put my images on each time, and then editing them to fit. It turned out very useful, so I'm sharing this as a spreadsheet. Like the Hair Database, other people are welcome to add information about custom content meshes. It includes the information about the Maxis paintings, that I took from @simlili's blog post, which is how it all started. She made an excellent post about it, I just wanted it arranged in a table. I also added a few more cc measurements by now. There are about 70 items there so far. How it works: Items are arranged by size in pixels, width first then height. For each painting I added it's ratio of W:H, this way I could quickly search for appropriate meshes throughout the database. No need to figure out if a 256x130 mesh is as good as a 170x98.. There's more basic info about each item, a link to its picture, and maybe some notes about recoloring it. I've put a link there to Simlili's post for more info by her.

I've added a place at the end where people can contribute information about custom content, and hopefully the database will be more extensive. I haven't seen this done before, if there is one I'd like to know about it. Hope you'll find it useful, have fun!

[starthereligious]

What to Add to Your (Digital) Grimoire

Having been reinvigorated into my practice by Apollo reaching out, I've just started a digital grimoire via Notion. I, of course, still have a physical grimoire/BOS, but I think I vastly prefer this version to my physical book. So here is a list of all the things that I have added to my book so far that you may benefit from in your own workings.

table of contents with each heading linking to its correlated section - this one is hard to explain. In Notion, you have the option to add "databases", which are exactly what they sound like. Each entry into the database creates its own separate page you can edit. In my case, my contents look like this:

When I click on each entry in the contents, I am taken to that page in a sidebar and am free to edit it to my liking. You can do this by adding a list view database.

calendar widget - There are calendar widgets built into Notion as its own specialized database. If you link your Google Calendar to your Notion calendar, you can add a calendar view database and add events to it. I added the full moons of the next couple months, my birthday, reminders of when to make moon water, and the next two solstices. If you follow the Wheel of the Year, this will likely be very useful for you.

a list of questions to ask divination - I have this formatted as a to-do list.

moon phase widget - Apption generates embed links for Notion for free, so all you have to do is find some code for a widget on a site and paste it into Apption. You will have to make an account to do this, but once you've generated the embed link. you won't have to revisit the site.

spellwork/witchy to-do list - I actually prefer a board view database for this. By default, a board view will give you three sections to put entries into: no status, in progress, and done. I renamed my no status section to "not started", because you can't delete the no status section.

table of herb correspondences - It's much easier to cross-reference correspondences digitally in multiple tabs. If you're well-versed in spreadsheets, this can simply be a link to Excel or Google Sheets. I, however, am not, so it's just a table directly in Notion for now.

For the actual grimoire, I like to organize everything into sections. I also suggest you add all digitally-kept spells as "mentions" rather than embeds or links, as it will display the title of the post and what platform it's on automatically.

If there is a post you particularly value, remember to back it up-- I recently went looking for my favorite herb correspondence post, only to find it had been deleted. Note down the post author, date of posting, date of access, anything you deem necessary. You can also archive it on the Wayback Machine, although the reliability of even that is shaky.

[trunao]

Document Generation: Produce Web App With Excel Online Spreadsheet!

Trunao is a pioneer in building a no-code web application, to convert an Excel spreadsheet into a web app with just a click. Excel to the online database is made easier with Trunao’s no-code application builder. If you want detailed info on how to create a spreadsheet online free, visit our blog now!

[kiragecko]

Help Choosing Online Spreadsheet Software?

I use spreadsheet software a lot, and sometimes I like to share the stuff I create. Which means using online software. I dislike Google Sheets for more than just being a Google product (copying data back and forth with other programs changes the formatting, they changed the search AGAIN so I don't currently know how to do it, etc).

Any advice about open source alternatives?

I'm leery of Open Office descendants because I STILL have Open Office documents from 2004 that I can't open in any program. But if people have good things to say about LibreOffice Calc (Online) I'm willing to try it out.

Collabora Online is the one I keep seeing in my research.

There's also Sheetster, OnlyOffice, Calligra Sheets, and many others.

I'm mostly making text databases, so ability to format and play with text is my priority.

I'd LOVE a program that let me transform the first character of cells (Excel will not let me add accents unless I type a dummy character before the one I'm going to transform.)

Searching and sorting need to work (I HATE YOU Google Sheets!)

I need to be able to link to it from here, people need to be able to see the file without creating an account, and it would also be nice if I could choose whether or not other people could edit it

Keeping text size, colour, and font when I copy/paste to or from Excel would be nice

For math, calculating percentages and averages would be nice. Mostly I'm just adding lists of numbers, but I've discovered that good percentage functions aren't a given

[sunsetforestzone]

>be me

>dont see myself as getting a lot of things from my mom as we are very different

>gets text from mom

>she's sending me a screenshot of her excel spreadsheet where she tracks money and organizes basically everything

>she sent me it to show me how much i owe her from the money i spent in my london trip

>i go "ok"

>opens up my notion page where my entire life is organized and goes to my money databases to write down the money i owe her, when i have to give it to her, how much i have left, and the amount that i should save for the month while i'm there

>closes notion

>pauses.

>oh god i am just like my mom

[pawbeanies]

using my absolutely cracked excel skills to create a spreadsheet of all my kinks. im making horny databases in access

[kirkgarden]

Tree Labeling in Agriculture: A Practical Guide for Farmers and Growers

Whether you’re running a small orchard, managing an agroforestry project, or operating a large-scale plantation, labeling your trees is one of the simplest but most powerful tools you can use. It helps you stay organized, track performance, and make informed decisions year after year.

In this guide, we’ll walk through why tree labeling matters, how to do it effectively (both physically and digitally), and practical tips to set up your own system. no matter your farm size or budget.

Why Label Trees on a Farm?

Labeling trees isn’t just for show. It plays a vital role in the daily operations and long-term health of your farm. Here’s why it's essential:

Tree Identification

Knowing the exact species or variety is key, especially in mixed orchards, experimental plots, or where grafted cultivars are involved. Accurate labels eliminate confusion.

Record-Keeping and Traceability

Labels allow you to link each tree to a digital record of its planting date, treatments, pruning, pest issues, and yields. This is crucial for certifications like Organic or GAP (Good Agricultural Practices).

Planning and Decision-Making

A well-labeled tree system helps with planning irrigation, pruning schedules, nutrient application, and even harvesting or replanting.

Worker Training and Efficiency

Field workers can be trained to use the labeling system to reduce mistakes, boost productivity, and communicate issues easily.

Types of Tree Labels

Depending on your goals, environment, and available resources, you can choose from various labeling methods — from simple handwritten tags to QR code-enabled digital systems.

1. Physical Labels (In the Field)

These are tags placed on or near each tree to allow for visual identification on-site.

Options:

Aluminum Tags: Weatherproof and long-lasting. Can be engraved or written on with permanent marker.

Plastic Tags: UV-resistant, cheaper, and color-coded. Good for short- to mid-term use.

Wooden Stakes: Ideal for nurseries or young seedlings before permanent labeling.

QR Code or RFID Tags: Scannable tech for advanced farms linking each tree to a database.

What to Include on the Label:

Tree ID (e.g., T-024)

Species and Cultivar (e.g., Mangifera indica – Alphonso)

Planting Date

Special Notes (e.g., Grafted, Zone 2B, Pest-prone)

Example Label:

Tree ID: T-024 Species: Mangifera indica (Alphonso) Planted: 2023-07-12 Notes: Grafted, Zone 2B

Best Practices:

Use UV-resistant ink or engrave to prevent fading.

Place labels on sturdy branches or stakes near the trunk.

Avoid wire directly on the bark — use flexible ties to prevent girdling.

Color-code for quick identification (e.g., green for productive, red for inspection needed).

2 Digital Labeling (Data Management)

A physical tag is just the beginning. To unlock the full value of tree labeling, connect your field system to a digital database.

Tools to Consider:

Spreadsheets: Google Sheets or Excel for small to mid-size farms.

Farm Management Apps: Like Croptracker, AgriWebb, FarmLogs.

GIS Mapping Tools: Useful for mapping tree locations, soil types, and water access.

Suggested Data Fields:

FieldExampleTree IDT-024Species/VarietyMangifera indica (Alphonso)GPS Location-1.2901, 36.8219Planting Date2023-07-12Health StatusHealthyYield History15 kg (2024), 22 kg (2025)NotesPruned in May 2025

Tip:

Make sure your physical label and digital record use the same Tree ID to avoid confusion.

Setting Up Your Tree Labeling System: Step-by-Step

Here’s a simple process you can follow to create an effective tree labeling system on your farm:

1. Develop a Tree ID Format

Use a consistent code. For example:

T-001 to T-500 for individual trees

A1-T045 for Block A1, Tree 45

2. Choose Label Materials

Pick a material based on durability, budget, and weather conditions. Aluminum tags last years. Plastic is more affordable and good for color-coding.

3. Create and Place Labels

Label trees shortly after planting and keep them visible but secure. Stake labels for seedlings or use hanging tags for mature trees.

4. Build a Digital Record

Start with a spreadsheet or use farm software. Log all essential details (see data table above) and update it after each season.

5. Train Your Team

Ensure workers understand how to read labels and update records. Use the system for pruning schedules, disease scouting, and yield logging.

Taking It Further: Tech Integration

If you're managing hundreds or thousands of trees, consider integrating technology:

QR Codes: Each code links to a full digital record. Can be scanned with a phone.

Drones or GPS tools: For mapping tree positions and checking health.

Irrigation + Sensor Data Integration: Label data can feed into smart irrigation decisions based on tree health and stage.

Final Thoughts

Tree labeling might seem like a small task, but it has a big impact on how efficiently and intelligently you run your farm. Whether you’re managing 10 or 10,000 trees, a good labeling system is the foundation for sustainable, productive agriculture.

Start simple, stay consistent, and as your farm grows, your tree labeling system will grow with it.

I hope this was helpful and happy gardening from Gardening with kirk

Here is a videos on additional tips on Pruning fruit trees 🌳

https://youtu.be/scvsi2oQK74?si=ENRGMxKrquBY8v9M

[womaneng]

View this post on Instagram

A post shared by Zeynep Küçük Woman Engineer (@woman.engineer)

Hey there! 🚀 Becoming a data analyst is an awesome journey! Here’s a roadmap for you:

1. Start with the Basics 📚:

- Dive into the basics of data analysis and statistics. 📊

- Platforms like Learnbay (Data Analytics Certification Program For Non-Tech Professionals), Edx, and Intellipaat offer fantastic courses. Check them out! 🎓

2. Master Excel 📈:

- Excel is your best friend! Learn to crunch numbers and create killer spreadsheets. 📊🔢

3. Get Hands-on with Tools 🛠️:

- Familiarize yourself with data analysis tools like SQL, Python, and R. Pluralsight has some great courses to level up your skills! 🐍📊

4. Data Visualization 📊:

- Learn to tell a story with your data. Tools like Tableau and Power BI can be game-changers! 📈📉

5. Build a Solid Foundation 🏗️:

- Understand databases, data cleaning, and data wrangling. It’s the backbone of effective analysis! 💪🔍

6. Machine Learning Basics 🤖:

- Get a taste of machine learning concepts. It’s not mandatory but can be a huge plus! 🤓🤖

7. Projects, Projects, Projects! 🚀:

- Apply your skills to real-world projects. It’s the best way to learn and showcase your abilities! 🌐💻

8. Networking is Key 👥:

- Connect with fellow data enthusiasts on LinkedIn, attend meetups, and join relevant communities. Networking opens doors! 🌐👋

9. Certifications 📜:

- Consider getting certified. It adds credibility to your profile. 🎓💼

10. Stay Updated 🔄:

- The data world evolves fast. Keep learning and stay up-to-date with the latest trends and technologies. 📆🚀

. . .